'''Creates the SQLite file'''
############################################################################
#    Copyright (C) 2006 by Robert Small                                    #
#    SmallR2002@Gmail.com                                                  #
#                                                                          #
#    This program is free software; you can redistribute it and#or modify  #
#    it under the terms of the GNU General Public License as published by  #
#    the Free Software Foundation; either version 2 of the License, or     #
#    (at your option) any later version.                                   #
#                                                                          #
#    This program is distributed in the hope that it will be useful,       #
#    but WITHOUT ANY WARRANTY; without even the implied warranty of        #
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the         #
#    GNU General Public License for more details.                          #
#                                                                          #
#    You should have received a copy of the GNU General Public License     #
#    along with this program; if not, write to the                         #
#    Free Software Foundation, Inc.,                                       #
#    59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.             #
############################################################################
import sqlite3, csv

csvMMGeoIP = csv.reader(open("<insert source file>"))

con = sqlite3.connect("<insert output file>")
curs = con.cursor()
curs.execute('CREATE TABLE MMGeoIP (Low INTEGER, High INTEGER, Country Text(100))')
curs.execute('CREATE INDEX idxLow ON MMGeoIP (Low)')
curs.execute('CREATE INDEX idxHigh ON MMGeoIP (High)')

for row in csvMMGeoIP:
    curs.execute('INSERT INTO MMGeoIP VALUES (?,?,?)', (row[2], row[3], row[5]))

con.commit()